Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	20000
Missing cells	8261
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.6 MiB
Average record size in memory	503.0 B

Variable types

Numeric	10
Categorical	6

Alerts

`name` has a high cardinality: 19768 distinct values	High cardinality
`host_name` has a high cardinality: 6517 distinct values	High cardinality
`neighbourhood` has a high cardinality: 217 distinct values	High cardinality
`last_review` has a high cardinality: 1507 distinct values	High cardinality
`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`latitude` is highly overall correlated with `neighbourhood_group`	High correlation
`longitude` is highly overall correlated with `neighbourhood_group`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`neighbourhood_group` is highly overall correlated with `latitude` and 1 other fields	High correlation
`last_review` has 4123 (20.6%) missing values	Missing
`reviews_per_month` has 4123 (20.6%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 25.17996962)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 4123 (20.6%) zeros	Zeros
`availability_365` has 7176 (35.9%) zeros	Zeros

Reproduction

Analysis started	2024-06-13 08:28:33.364863
Analysis finished	2024-06-13 08:28:40.384519
Duration	7.02 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	20000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18923801

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2539
5-th percentile	1193873.9
Q1	9393540.5
median	19521168
Q3	29129359
95-th percentile	35275607
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19735818

Descriptive statistics

Standard deviation	11012232
Coefficient of variation (CV)	0.58192498
Kurtosis	-1.233323
Mean	18923801
Median Absolute Deviation (MAD)	9896304
Skewness	-0.075380527
Sum	3.7847602 × 10¹¹
Variance	1.2126926 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
13746962	1	< 0.1%
449130	1	< 0.1%
7885044	1	< 0.1%
31315168	1	< 0.1%
16341416	1	< 0.1%
16133101	1	< 0.1%
17922181	1	< 0.1%
28972637	1	< 0.1%
20917712	1	< 0.1%
Other values (19990)	19990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%

name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	19768
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	1.8 MiB

Brooklyn Apartment	7
Hillside Hotel	7
Private Room	6
New york Multi-unit building	6
Home away from home	6
Other values (19763)	19961

Length

Max length	179
Median length	68
Mean length	36.902466
Min length	1

Characters and Unicode

Total characters	737791
Distinct characters	511
Distinct categories	20 ?
Distinct scripts	11 ?
Distinct blocks	17 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19599 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Common Values

Value	Count	Frequency (%)
Brooklyn Apartment	7	< 0.1%
Hillside Hotel	7	< 0.1%
Private Room	6	< 0.1%
New york Multi-unit building	6	< 0.1%
Home away from home	6	< 0.1%
Cozy Room	5	< 0.1%
Private room in Manhattan	5	< 0.1%
Private room in Williamsburg	4	< 0.1%
Cozy Private Room	4	< 0.1%
❤ of Manhattan \| Fantastic 1 Bedroom	3	< 0.1%
Other values (19758)	19940	99.7%
(Missing)	7	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	6813	5.6%
room	4038	3.3%
	3388	2.8%
bedroom	3145	2.6%
private	2935	2.4%
apartment	2748	2.2%
cozy	2034	1.7%
apt	1843	1.5%
brooklyn	1666	1.4%
the	1620	1.3%
Other values (7025)	91941	75.3%

Most occurring characters

Value	Count	Frequency (%)
	102878	13.9%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.7%
r	40165	5.4%
i	38708	5.2%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (501)	289869	39.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	493004	66.8%
Uppercase Letter	110782	15.0%
Space Separator	102880	13.9%
Other Punctuation	13747	1.9%
Decimal Number	10518	1.4%
Dash Punctuation	2806	0.4%
Math Symbol	1072	0.1%
Other Letter	987	0.1%
Close Punctuation	647	0.1%
Open Punctuation	593	0.1%
Other values (10)	755	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
房	37	3.7%
间	22	2.2%
中	21	2.1%
拉	20	2.0%
盛	19	1.9%
法	19	1.9%
家	16	1.6%
温	15	1.5%
的	15	1.5%
馨	13	1.3%
Other values (301)	790	80.0%

Lowercase Letter

Value	Count	Frequency (%)
e	50869	10.3%
o	50103	10.2%
t	42994	8.7%
a	42392	8.6%
r	40165	8.1%
i	38708	7.9%
n	38494	7.8%
l	21159	4.3%
m	20160	4.1%
s	19736	4.0%
Other values (48)	128224	26.0%

Other Symbol

Value	Count	Frequency (%)
★	129	32.9%
❤	70	17.9%
☆	31	7.9%
⭐	19	4.8%
✨	17	4.3%
♥	14	3.6%
❥	13	3.3%
✰	8	2.0%
✿	7	1.8%
⚡	6	1.5%
Other values (32)	78	19.9%

Uppercase Letter

Value	Count	Frequency (%)
B	12285	11.1%
S	10802	9.8%
C	8612	7.8%
A	7957	7.2%
R	7399	6.7%
P	6047	5.5%
E	5906	5.3%
L	5757	5.2%
M	4841	4.4%
T	4763	4.3%
Other values (23)	36413	32.9%

Other Punctuation

Value	Count	Frequency (%)
,	3685	26.8%
!	3209	23.3%
/	2153	15.7%
.	1778	12.9%
&	1292	9.4%
'	441	3.2%
*	402	2.9%
:	239	1.7%
#	232	1.7%
"	113	0.8%
Other values (9)	203	1.5%

Decimal Number

Value	Count	Frequency (%)
1	3559	33.8%
2	2852	27.1%
3	1087	10.3%
5	916	8.7%
0	841	8.0%
4	562	5.3%
6	253	2.4%
8	167	1.6%
7	164	1.6%
9	117	1.1%

Math Symbol

Value	Count	Frequency (%)
+	529	49.3%
\|	397	37.0%
~	108	10.1%
=	12	1.1%
>	10	0.9%
<	7	0.7%
￫	6	0.6%
√	2	0.2%
×	1	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	621	96.0%
]	17	2.6%
}	4	0.6%
】	3	0.5%
》	2	0.3%

Open Punctuation

Value	Count	Frequency (%)
(	568	95.8%
[	16	2.7%
{	4	0.7%
【	3	0.5%
《	2	0.3%

Dash Punctuation

Value	Count	Frequency (%)
-	2771	98.8%
—	19	0.7%
–	16	0.6%

Space Separator

Value	Count	Frequency (%)
	102878	> 99.9%
	2	< 0.1%

Final Punctuation

Value	Count	Frequency (%)
’	95	87.2%
”	14	12.8%

Nonspacing Mark

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Initial Punctuation

Value	Count	Frequency (%)
“	15	78.9%
‘	4	21.1%

Modifier Letter

Value	Count	Frequency (%)
ﾞ	7	70.0%
ｰ	3	30.0%

Modifier Symbol

Value	Count	Frequency (%)
^	6	85.7%
`	1	14.3%

Control

Value	Count	Frequency (%)
	74	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	36	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	20	100.0%

Other Number

Value	Count	Frequency (%)
²	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	603703	81.8%
Common	132937	18.0%
Han	889	0.1%
Inherited	81	< 0.1%
Cyrillic	71	< 0.1%
Katakana	45	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Hiragana	12	< 0.1%
Hangul	8	< 0.1%

Most frequent character per script

Han

Value	Count	Frequency (%)
房	37	4.2%
间	22	2.5%
中	21	2.4%
拉	20	2.2%
盛	19	2.1%
法	19	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (246)	692	77.8%

Common

Value	Count	Frequency (%)
	102878	77.4%
,	3685	2.8%
1	3559	2.7%
!	3209	2.4%
2	2852	2.1%
-	2771	2.1%
/	2153	1.6%
.	1778	1.3%
&	1292	1.0%
3	1087	0.8%
Other values (97)	7673	5.8%

Latin

Value	Count	Frequency (%)
e	50869	8.4%
o	50103	8.3%
t	42994	7.1%
a	42392	7.0%
r	40165	6.7%
i	38708	6.4%
n	38494	6.4%
l	21159	3.5%
m	20160	3.3%
s	19736	3.3%
Other values (61)	238923	39.6%

Katakana

Value	Count	Frequency (%)
ﾝ	7	15.6%
ﾄ	5	11.1%
ｯ	3	6.7%
ｳ	3	6.7%
ﾀ	3	6.7%
ｸ	3	6.7%
ｽ	2	4.4%
ﾐ	2	4.4%
ｲ	1	2.2%
ｻ	1	2.2%
Other values (15)	15	33.3%

Cyrillic

Value	Count	Frequency (%)
а	10	14.1%
т	7	9.9%
н	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
е	4	5.6%
м	4	5.6%
р	3	4.2%
я	3	4.2%
Other values (9)	16	22.5%

Hebrew

Value	Count	Frequency (%)
ו	5	16.1%
י	5	16.1%
ר	4	12.9%
ב	4	12.9%
ה	2	6.5%
ע	2	6.5%
ת	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Hangul

Value	Count	Frequency (%)
물	1	12.5%
웃	1	12.5%
따	1	12.5%
뜻	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
한	1	12.5%

Hiragana

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
い	1	8.3%
に	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Inherited

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Georgian

Value	Count	Frequency (%)
ღ	12	100.0%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	735931	99.7%
CJK	889	0.1%
Misc Symbols	220	< 0.1%
Punctuation	200	< 0.1%
None	182	< 0.1%
Dingbats	143	< 0.1%
VS	81	< 0.1%
Cyrillic	71	< 0.1%
Hebrew	31	< 0.1%
Georgian	12	< 0.1%
Other values (7)	31	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	102878	14.0%
e	50869	6.9%
o	50103	6.8%
t	42994	5.8%
a	42392	5.8%
r	40165	5.5%
i	38708	5.3%
n	38494	5.2%
l	21159	2.9%
m	20160	2.7%
Other values (86)	288009	39.1%

Misc Symbols

Value	Count	Frequency (%)
★	129	58.6%
☆	31	14.1%
♥	14	6.4%
⚡	6	2.7%
♦	6	2.7%
☀	6	2.7%
♀	5	2.3%
☺	3	1.4%
♕	3	1.4%
⚓	3	1.4%
Other values (8)	14	6.4%

Punctuation

Value	Count	Frequency (%)
’	95	47.5%
•	37	18.5%
—	19	9.5%
–	16	8.0%
“	15	7.5%
”	14	7.0%
‘	4	2.0%

VS

Value	Count	Frequency (%)
️	72	88.9%
︎	9	11.1%

Dingbats

Value	Count	Frequency (%)
❤	70	49.0%
✨	17	11.9%
❥	13	9.1%
✰	8	5.6%
✿	7	4.9%
✪	5	3.5%
✦	4	2.8%
✴	4	2.8%
✮	3	2.1%
✤	3	2.1%
Other values (5)	9	6.3%

CJK

Value	Count	Frequency (%)
房	37	4.2%
间	22	2.5%
中	21	2.4%
拉	20	2.2%
盛	19	2.1%
法	19	2.1%
家	16	1.8%
温	15	1.7%
的	15	1.7%
馨	13	1.5%
Other values (246)	692	77.8%

None

Value	Count	Frequency (%)
⭐	19	10.4%
à	15	8.2%
ó	9	4.9%
·	7	3.8%
é	7	3.8%
ﾝ	7	3.8%
ﾞ	7	3.8%
｡	7	3.8%
²	7	3.8%
￫	6	3.3%
Other values (51)	91	50.0%

Georgian

Value	Count	Frequency (%)
ღ	12	100.0%

Cyrillic

Value	Count	Frequency (%)
а	10	14.1%
т	7	9.9%
н	7	9.9%
о	6	8.5%
с	6	8.5%
к	5	7.0%
е	4	5.6%
м	4	5.6%
р	3	4.2%
я	3	4.2%
Other values (9)	16	22.5%

Hebrew

Value	Count	Frequency (%)
ו	5	16.1%
י	5	16.1%
ר	4	12.9%
ב	4	12.9%
ה	2	6.5%
ע	2	6.5%
ת	2	6.5%
ד	1	3.2%
ש	1	3.2%
ל	1	3.2%
Other values (4)	4	12.9%

Hiragana

Value	Count	Frequency (%)
の	5	41.7%
お	2	16.7%
い	1	8.3%
に	1	8.3%
な	1	8.3%
で	1	8.3%
す	1	8.3%

Devanagari

Value	Count	Frequency (%)
ॐ	2	100.0%

Misc Technical

Value	Count	Frequency (%)
⍟	2	50.0%
⏩	1	25.0%
⏪	1	25.0%

Math Operators

Value	Count	Frequency (%)
√	2	100.0%

Geometric Shapes

Value	Count	Frequency (%)
▲	2	100.0%

Letterlike Symbols

Value	Count	Frequency (%)
™	1	100.0%

Hangul

Value	Count	Frequency (%)
물	1	12.5%
웃	1	12.5%
따	1	12.5%
뜻	1	12.5%
작	1	12.5%
은	1	12.5%
건	1	12.5%
한	1	12.5%

host_id
Real number (ℝ)

Distinct	17027
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67460344

Minimum	2571
Maximum	2.7427328 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	2571
5-th percentile	779450
Q1	7853718.2
median	31114310
Q3	1.0684256 × 10⁸
95-th percentile	2.4209584 × 10⁸
Maximum	2.7427328 × 10⁸
Range	2.7427071 × 10⁸
Interquartile range (IQR)	98988842

Descriptive statistics

Standard deviation	78579365
Coefficient of variation (CV)	1.1648231
Kurtosis	0.20879863
Mean	67460344
Median Absolute Deviation (MAD)	27863860
Skewness	1.219649
Sum	1.3492069 × 10¹²
Variance	6.1747166 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	131	0.7%
107434423	89	0.4%
30283594	53	0.3%
12243051	37	0.2%
16098958	36	0.2%
137358866	36	0.2%
61391963	34	0.2%
22541573	32	0.2%
200380610	27	0.1%
26377263	24	0.1%
Other values (17017)	19501	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
274079964	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273812306	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273632292	1	< 0.1%

host_name
Categorical

Distinct	6517
Distinct (%)	32.6%
Missing	8
Missing (%)	< 0.1%
Memory size	1.2 MiB

David	170
Michael	167
John	133
Sonder (NYC)	131
Alex	105
Other values (6512)	19286

Length

Max length	35
Median length	31
Mean length	6.112445
Min length	1

Characters and Unicode

Total characters	122200
Distinct characters	140
Distinct categories	11 ?
Distinct scripts	6 ?
Distinct blocks	7 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4203 ?
Unique (%)	21.0%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Common Values

Value	Count	Frequency (%)
David	170	0.9%
Michael	167	0.8%
John	133	0.7%
Sonder (NYC)	131	0.7%
Alex	105	0.5%
Daniel	95	0.5%
Blueground	89	0.4%
Sarah	87	0.4%
Maria	87	0.4%
Chris	83	0.4%
Other values (6507)	18845	94.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	428	1.9%
and	250	1.1%
david	185	0.8%
michael	183	0.8%
sonder	168	0.8%
john	148	0.7%
nyc	137	0.6%
alex	129	0.6%
laura	121	0.5%
maria	109	0.5%
Other values (6048)	20426	91.7%

Most occurring characters

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.6%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (130)	45127	36.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	96373	78.9%
Uppercase Letter	22409	18.3%
Space Separator	2334	1.9%
Other Punctuation	616	0.5%
Close Punctuation	149	0.1%
Open Punctuation	149	0.1%
Dash Punctuation	77	0.1%
Other Letter	41	< 0.1%
Decimal Number	36	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	15469	16.1%
e	11787	12.2%
i	9892	10.3%
n	9892	10.3%
r	7360	7.6%
l	6239	6.5%
o	5194	5.4%
t	3817	4.0%
s	3737	3.9%
h	3686	3.8%
Other values (46)	19300	20.0%

Uppercase Letter

Value	Count	Frequency (%)
A	2627	11.7%
J	2215	9.9%
M	2152	9.6%
S	1914	8.5%
C	1517	6.8%
L	1177	5.3%
D	1132	5.1%
R	1085	4.8%
K	1070	4.8%
E	970	4.3%
Other values (22)	6550	29.2%

Other Letter

Value	Count	Frequency (%)
美	3	7.3%
德	3	7.3%
青	3	7.3%
明	3	7.3%
柏	2	4.9%
辣	2	4.9%
润	2	4.9%
铀	2	4.9%
ゆ	1	2.4%
竹	1	2.4%
Other values (19)	19	46.3%

Other Punctuation

Value	Count	Frequency (%)
&	445	72.2%
.	129	20.9%
/	14	2.3%
,	13	2.1%
'	7	1.1%
!	4	0.6%
@	3	0.5%
:	1	0.2%

Decimal Number

Value	Count	Frequency (%)
5	11	30.6%
0	6	16.7%
7	6	16.7%
1	4	11.1%
2	3	8.3%
4	3	8.3%
6	2	5.6%
3	1	2.8%

Space Separator

Value	Count	Frequency (%)
	2330	99.8%
	4	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	149	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	149	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	77	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Currency Symbol

Value	Count	Frequency (%)
£	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	118759	97.2%
Common	3377	2.8%
Han	36	< 0.1%
Cyrillic	23	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	15469	13.0%
e	11787	9.9%
i	9892	8.3%
n	9892	8.3%
r	7360	6.2%
l	6239	5.3%
o	5194	4.4%
t	3817	3.2%
s	3737	3.1%
h	3686	3.1%
Other values (63)	41686	35.1%

Han

Value	Count	Frequency (%)
美	3	8.3%
德	3	8.3%
青	3	8.3%
明	3	8.3%
柏	2	5.6%
辣	2	5.6%
润	2	5.6%
铀	2	5.6%
竹	1	2.8%
莹	1	2.8%
Other values (14)	14	38.9%

Common

Value	Count	Frequency (%)
	2330	69.0%
&	445	13.2%
)	149	4.4%
(	149	4.4%
.	129	3.8%
-	77	2.3%
+	15	0.4%
/	14	0.4%
,	13	0.4%
5	11	0.3%
Other values (13)	45	1.3%

Cyrillic

Value	Count	Frequency (%)
е	3	13.0%
А	3	13.0%
и	2	8.7%
н	2	8.7%
л	2	8.7%
й	2	8.7%
д	1	4.3%
р	1	4.3%
а	1	4.3%
Т	1	4.3%
Other values (5)	5	21.7%

Hiragana

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Hangul

Value	Count	Frequency (%)
정	1	50.0%
소	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	122025	99.9%
None	107	0.1%
CJK	36	< 0.1%
Cyrillic	23	< 0.1%
Punctuation	4	< 0.1%
Hiragana	3	< 0.1%
Hangul	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	15469	12.7%
e	11787	9.7%
i	9892	8.1%
n	9892	8.1%
r	7360	6.0%
l	6239	5.1%
o	5194	4.3%
t	3817	3.1%
s	3737	3.1%
h	3686	3.0%
Other values (63)	44952	36.8%

None

Value	Count	Frequency (%)
é	43	40.2%
á	10	9.3%
í	10	9.3%
ë	8	7.5%
è	6	5.6%
ô	6	5.6%
ú	5	4.7%
ï	2	1.9%
ı	2	1.9%
ç	2	1.9%
Other values (12)	13	12.1%

Punctuation

Value	Count	Frequency (%)
	4	100.0%

Cyrillic

Value	Count	Frequency (%)
е	3	13.0%
А	3	13.0%
и	2	8.7%
н	2	8.7%
л	2	8.7%
й	2	8.7%
д	1	4.3%
р	1	4.3%
а	1	4.3%
Т	1	4.3%
Other values (5)	5	21.7%

CJK

Value	Count	Frequency (%)
美	3	8.3%
德	3	8.3%
青	3	8.3%
明	3	8.3%
柏	2	5.6%
辣	2	5.6%
润	2	5.6%
铀	2	5.6%
竹	1	2.8%
莹	1	2.8%
Other values (14)	14	38.9%

Hiragana

Value	Count	Frequency (%)
ゆ	1	33.3%
り	1	33.3%
あ	1	33.3%

Hangul

Value	Count	Frequency (%)
정	1	50.0%
소	1	50.0%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Manhattan	8774
Brooklyn	8265
Queens	2355
Bronx	441
Staten Island	165

Length

Max length	13
Median length	9
Mean length	8.1783
Min length	5

Characters and Unicode

Total characters	163566
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Manhattan	8774	43.9%
Brooklyn	8265	41.3%
Queens	2355	11.8%
Bronx	441	2.2%
Staten Island	165	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
manhattan	8774	43.5%
brooklyn	8265	41.0%
queens	2355	11.7%
bronx	441	2.2%
staten	165	0.8%
island	165	0.8%

Most occurring characters

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	143236	87.6%
Uppercase Letter	20165	12.3%
Space Separator	165	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	28939	20.2%
a	26652	18.6%
t	17878	12.5%
o	16971	11.8%
h	8774	6.1%
r	8706	6.1%
l	8430	5.9%
y	8265	5.8%
k	8265	5.8%
e	4875	3.4%
Other values (4)	5481	3.8%

Uppercase Letter

Value	Count	Frequency (%)
M	8774	43.5%
B	8706	43.2%
Q	2355	11.7%
S	165	0.8%
I	165	0.8%

Space Separator

Value	Count	Frequency (%)
	165	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	163401	99.9%
Common	165	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (9)	21306	13.0%

Common

Value	Count	Frequency (%)
	165	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	163566	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	28939	17.7%
a	26652	16.3%
t	17878	10.9%
o	16971	10.4%
M	8774	5.4%
h	8774	5.4%
B	8706	5.3%
r	8706	5.3%
l	8430	5.2%
y	8265	5.1%
Other values (10)	21471	13.1%

neighbourhood
Categorical

Distinct	217
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Williamsburg	1580
Bedford-Stuyvesant	1503
Harlem	1116
Bushwick	987
Upper West Side	798
Other values (212)	14016

Length

Max length	26
Median length	17
Mean length	11.8819
Min length	4

Characters and Unicode

Total characters	237638
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Common Values

Value	Count	Frequency (%)
Williamsburg	1580	7.9%
Bedford-Stuyvesant	1503	7.5%
Harlem	1116	5.6%
Bushwick	987	4.9%
Upper West Side	798	4.0%
Hell's Kitchen	771	3.9%
East Village	756	3.8%
Upper East Side	706	3.5%
Crown Heights	648	3.2%
Midtown	643	3.2%
Other values (207)	10492	52.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	2690	8.3%
side	1872	5.8%
williamsburg	1580	4.9%
harlem	1579	4.9%
upper	1504	4.7%
bedford-stuyvesant	1503	4.6%
heights	1462	4.5%
village	1301	4.0%
west	1142	3.5%
bushwick	987	3.1%
Other values (229)	16713	51.7%

Most occurring characters

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	188434	79.3%
Uppercase Letter	34309	14.4%
Space Separator	12333	5.2%
Dash Punctuation	1736	0.7%
Other Punctuation	826	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	21824	11.6%
i	17188	9.1%
s	16285	8.6%
t	15839	8.4%
a	15504	8.2%
l	14091	7.5%
r	13837	7.3%
n	10687	5.7%
o	9832	5.2%
d	7969	4.2%
Other values (15)	45378	24.1%

Uppercase Letter

Value	Count	Frequency (%)
H	4904	14.3%
S	4653	13.6%
B	3373	9.8%
W	3327	9.7%
E	2888	8.4%
C	2238	6.5%
U	1535	4.5%
G	1532	4.5%
F	1380	4.0%
V	1324	3.9%
Other values (14)	7155	20.9%

Other Punctuation

Value	Count	Frequency (%)
'	776	93.9%
.	49	5.9%
,	1	0.1%

Space Separator

Value	Count	Frequency (%)
	12333	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1736	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	222743	93.7%
Common	14895	6.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	21824	9.8%
i	17188	7.7%
s	16285	7.3%
t	15839	7.1%
a	15504	7.0%
l	14091	6.3%
r	13837	6.2%
n	10687	4.8%
o	9832	4.4%
d	7969	3.6%
Other values (39)	79687	35.8%

Common

Value	Count	Frequency (%)
	12333	82.8%
-	1736	11.7%
'	776	5.2%
.	49	0.3%
,	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237638	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	21824	9.2%
i	17188	7.2%
s	16285	6.9%
t	15839	6.7%
a	15504	6.5%
l	14091	5.9%
r	13837	5.8%
	12333	5.2%
n	10687	4.5%
o	9832	4.1%
Other values (44)	90218	38.0%

latitude
Real number (ℝ)

Distinct	12439
Distinct (%)	62.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.728455

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64513
Q1	40.68942
median	40.72273
Q3	40.76299
95-th percentile	40.825653
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07357

Descriptive statistics

Standard deviation	0.054755077
Coefficient of variation (CV)	0.0013443937
Kurtosis	0.10856551
Mean	40.728455
Median Absolute Deviation (MAD)	0.03658
Skewness	0.23016938
Sum	814569.1
Variance	0.0029981185
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	8	< 0.1%
40.69414	8	< 0.1%
40.68634	8	< 0.1%
40.72232	8	< 0.1%
40.68683	7	< 0.1%
40.71801	7	< 0.1%
40.68084	7	< 0.1%
40.70587	7	< 0.1%
40.72607	7	< 0.1%
40.6898	6	< 0.1%
Other values (12429)	19927	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53076	1	< 0.1%
40.53871	1	< 0.1%
40.53884	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%

longitude
Real number (ℝ)

Distinct	10181
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.952125

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	20000
Negative (%)	100.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.004181
Q1	-73.98303
median	-73.95564
Q3	-73.93638
95-th percentile	-73.864896
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04665

Descriptive statistics

Standard deviation	0.046558783
Coefficient of variation (CV)	-0.00062958006
Kurtosis	4.9382429
Mean	-73.952125
Median Absolute Deviation (MAD)	0.024895
Skewness	1.2551004
Sum	-1479042.5
Variance	0.0021677203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.98589	10	0.1%
-73.95742	9	< 0.1%
-73.94829	9	< 0.1%
-73.95121	9	< 0.1%
-73.95427	9	< 0.1%
-73.95725	9	< 0.1%
-73.98043	9	< 0.1%
-73.95677	8	< 0.1%
-73.98874	8	< 0.1%
-73.98985	8	< 0.1%
Other values (10171)	19912	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.20295	1	< 0.1%
-74.19826	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Entire home/apt	10384
Private room	9172
Shared room	444

Length

Max length	15
Median length	15
Mean length	13.5354
Min length	11

Characters and Unicode

Total characters	270708
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	10384	51.9%
Private room	9172	45.9%
Shared room	444	2.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	10384	26.0%
home/apt	10384	26.0%
room	9616	24.0%
private	9172	22.9%
shared	444	1.1%

Most occurring characters

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	220324	81.4%
Space Separator	20000	7.4%
Uppercase Letter	20000	7.4%
Other Punctuation	10384	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	30384	13.8%
t	29940	13.6%
o	29616	13.4%
r	29616	13.4%
a	20000	9.1%
m	20000	9.1%
i	19556	8.9%
h	10828	4.9%
p	10384	4.7%
n	10384	4.7%
Other values (2)	9616	4.4%

Uppercase Letter

Value	Count	Frequency (%)
E	10384	51.9%
P	9172	45.9%
S	444	2.2%

Space Separator

Value	Count	Frequency (%)
	20000	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	10384	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	240324	88.8%
Common	30384	11.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	30384	12.6%
t	29940	12.5%
o	29616	12.3%
r	29616	12.3%
a	20000	8.3%
m	20000	8.3%
i	19556	8.1%
h	10828	4.5%
p	10384	4.3%
E	10384	4.3%
Other values (5)	29616	12.3%

Common

Value	Count	Frequency (%)
	20000	65.8%
/	10384	34.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	270708	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	30384	11.2%
t	29940	11.1%
o	29616	10.9%
r	29616	10.9%
a	20000	7.4%
	20000	7.4%
m	20000	7.4%
i	19556	7.2%
h	10828	4.0%
p	10384	3.8%
Other values (7)	50384	18.6%

price
Real number (ℝ)

Distinct	544
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	153.26905

Minimum	0
Maximum	10000
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	69
median	105
Q3	175
95-th percentile	350
Maximum	10000
Range	10000
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	243.32561
Coefficient of variation (CV)	1.5875717
Kurtosis	538.29758
Mean	153.26905
Median Absolute Deviation (MAD)	45
Skewness	18.30469
Sum	3065381
Variance	59207.352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.3%
150	821	4.1%
50	636	3.2%
200	590	2.9%
75	570	2.9%
60	555	2.8%
80	531	2.7%
70	482	2.4%
65	471	2.4%
120	471	2.4%
Other values (534)	14017	70.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	< 0.1%
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	3	< 0.1%
20	13	0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
8500	1	< 0.1%
7703	1	< 0.1%
7500	1	< 0.1%
6500	2	< 0.1%
5250	1	< 0.1%
5100	1	< 0.1%
5000	1	< 0.1%
4500	2	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.9921

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.645449
Coefficient of variation (CV)	3.0957007
Kurtosis	1072.1676
Mean	6.9921
Median Absolute Deviation (MAD)	1
Skewness	25.17997
Sum	139842
Variance	468.52546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
30	1540	7.7%
4	1328	6.6%
5	1208	6.0%
7	855	4.3%
6	307	1.5%
14	217	1.1%
10	183	0.9%
Other values (65)	1009	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
4	1328	6.6%
5	1208	6.0%
6	307	1.5%
7	855	4.3%
8	52	0.3%
9	34	0.2%
10	183	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%
365	14	0.1%
364	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
240	2	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	323
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.2741

Minimum	0
Maximum	607
Zeros	4123
Zeros (%)	20.6%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	23
95-th percentile	114
Maximum	607
Range	607
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	44.927793
Coefficient of variation (CV)	1.9303772
Kurtosis	20.229807
Mean	23.2741
Median Absolute Deviation (MAD)	5
Skewness	3.7613755
Sum	465482
Variance	2018.5066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%
Other values (313)	7919	39.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
447	1	< 0.1%

last_review
Categorical

HIGH CARDINALITY MISSING

Distinct	1507
Distinct (%)	9.5%
Missing	4123
Missing (%)	20.6%
Memory size	1.1 MiB

2019-06-23	575
2019-07-01	557
2019-06-30	553
2019-06-24	350
2019-07-07	292
Other values (1502)	13550

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	158770
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	358 ?
Unique (%)	2.3%

Sample

1st row	2019-05-26
2nd row	2018-09-19
3rd row	2019-05-24
4th row	2019-06-23
5th row	2018-08-28

Common Values

Value	Count	Frequency (%)
2019-06-23	575	2.9%
2019-07-01	557	2.8%
2019-06-30	553	2.8%
2019-06-24	350	1.8%
2019-07-07	292	1.5%
2019-07-02	280	1.4%
2019-06-22	270	1.4%
2019-07-05	252	1.3%
2019-06-16	245	1.2%
2019-07-06	240	1.2%
Other values (1497)	12263	61.3%
(Missing)	4123	20.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-06-23	575	3.6%
2019-07-01	557	3.5%
2019-06-30	553	3.5%
2019-06-24	350	2.2%
2019-07-07	292	1.8%
2019-07-02	280	1.8%
2019-06-22	270	1.7%
2019-07-05	252	1.6%
2019-06-16	245	1.5%
2019-07-06	240	1.5%
Other values (1497)	12263	77.2%

Most occurring characters

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	127016	80.0%
Dash Punctuation	31754	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	37740	29.7%
1	25367	20.0%
2	23933	18.8%
9	12270	9.7%
6	8098	6.4%
7	5309	4.2%
8	4494	3.5%
5	3914	3.1%
3	3634	2.9%
4	2257	1.8%

Dash Punctuation

Value	Count	Frequency (%)
-	31754	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	158770	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	158770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	37740	23.8%
-	31754	20.0%
1	25367	16.0%
2	23933	15.1%
9	12270	7.7%
6	8098	5.1%
7	5309	3.3%
8	4494	2.8%
5	3914	2.5%
3	3634	2.3%

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	790
Distinct (%)	5.0%
Missing	4123
Missing (%)	20.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.377446

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.67
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.6830056
Coefficient of variation (CV)	1.2218306
Kurtosis	11.9517
Mean	1.377446
Median Absolute Deviation (MAD)	0.62
Skewness	2.4357993
Sum	21869.71
Variance	2.8325079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	378	1.9%
0.02	378	1.9%
0.05	352	1.8%
0.03	334	1.7%
0.04	274	1.4%
0.08	263	1.3%
0.16	255	1.3%
0.09	246	1.2%
0.06	234	1.2%
0.11	222	1.1%
Other values (780)	12941	64.7%
(Missing)	4123	20.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	18	0.1%
0.02	378	1.9%
0.03	334	1.7%
0.04	274	1.4%
0.05	352	1.8%
0.06	234	1.2%
0.07	172	0.9%
0.08	263	1.3%
0.09	246	1.2%
0.1	198	1.0%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
14	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.95545

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	14
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	32.433831
Coefficient of variation (CV)	4.6630815
Kurtosis	70.365352
Mean	6.95545
Median Absolute Deviation (MAD)	0
Skewness	8.0961239
Sum	139109
Variance	1051.9534
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
8	168	0.8%
7	166	0.8%
327	131	0.7%
9	103	0.5%
Other values (37)	1123	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
7	166	0.8%
8	168	0.8%
9	103	0.5%
10	70	0.4%

Value	Count	Frequency (%)
327	131	0.7%
232	89	0.4%
121	53	0.3%
103	36	0.2%
96	73	0.4%
91	34	0.2%
87	32	0.2%
65	27	0.1%
52	41	0.2%
50	16	0.1%

availability_365
Real number (ℝ)

Distinct	366
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	112.9012

Minimum	0
Maximum	365
Zeros	7176
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	156.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44
Q3	229
95-th percentile	359
Maximum	365
Range	365
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	131.76223
Coefficient of variation (CV)	1.1670578
Kurtosis	-1.0070922
Mean	112.9012
Median Absolute Deviation (MAD)	44
Skewness	0.75940929
Sum	2258024
Variance	17361.284
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7176	35.9%
365	510	2.5%
364	225	1.1%
1	181	0.9%
5	136	0.7%
89	124	0.6%
179	121	0.6%
2	119	0.6%
3	118	0.6%
6	110	0.5%
Other values (356)	11180	55.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7176	35.9%
1	181	0.9%
2	119	0.6%
3	118	0.6%
4	110	0.5%
5	136	0.7%
6	110	0.5%
7	98	0.5%
8	85	0.4%
9	85	0.4%

Value	Count	Frequency (%)
365	510	2.5%
364	225	1.1%
363	98	0.5%
362	69	0.3%
361	48	0.2%
360	34	0.2%
359	52	0.3%
358	62	0.3%
357	37	0.2%
356	28	0.1%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood_group	room_type
id	1.000	0.558	-0.001	0.067	-0.027	-0.068	-0.302	0.369	0.133	0.165	0.059	0.071
host_id	0.558	1.000	0.042	0.107	-0.074	-0.139	-0.118	0.276	0.145	0.173	0.098	0.092
latitude	-0.001	0.042	1.000	0.040	0.139	0.017	-0.038	-0.027	0.002	-0.010	0.538	0.112
longitude	0.067	0.107	0.040	1.000	-0.437	-0.121	0.081	0.117	0.063	0.061	0.649	0.154
price	-0.027	-0.074	0.139	-0.437	1.000	0.103	-0.051	-0.019	-0.101	0.092	0.010	0.023
minimum_nights	-0.068	-0.139	0.017	-0.121	0.103	1.000	-0.159	-0.288	0.064	0.081	0.000	0.020
number_of_reviews	-0.302	-0.118	-0.038	0.081	-0.051	-0.159	1.000	0.702	0.057	0.238	0.027	0.000
reviews_per_month	0.369	0.276	-0.027	0.117	-0.019	-0.288	0.702	1.000	0.144	0.388	0.066	0.017
calculated_host_listings_count	0.133	0.145	0.002	0.063	-0.101	0.064	0.057	0.144	1.000	0.407	0.086	0.095
availability_365	0.165	0.173	-0.010	0.061	0.092	0.081	0.238	0.388	0.407	1.000	0.076	0.089
neighbourhood_group	0.059	0.098	0.538	0.649	0.010	0.000	0.027	0.066	0.086	0.076	1.000	0.125
room_type	0.071	0.092	0.112	0.154	0.023	0.020	0.000	0.017	0.095	0.089	0.125	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaN	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaN	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Other Symbol

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Close Punctuation

Open Punctuation

Dash Punctuation

Space Separator

Final Punctuation

Nonspacing Mark

Initial Punctuation

Modifier Letter

Modifier Symbol

Control

Currency Symbol

Connector Punctuation

Other Number

Most occurring scripts

Most frequent character per script

Han

Common

Latin

Katakana

Cyrillic

Hebrew

Hangul

Hiragana

Inherited

Georgian

Devanagari

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

VS

Dingbats

CJK

None

Georgian

Cyrillic

Hebrew

Hiragana

Devanagari

Misc Technical

Math Operators

Geometric Shapes

Letterlike Symbols

Hangul

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Letter

Other Punctuation

Decimal Number

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Math Symbol

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Han

Common